SELECT	Name AS Naam,
		AantalAlbums AS "Aantal Albums",
		(IIF(EigenAlbums IS NOT NULL,EigenAlbums,0)) AS "Aantal Eigen Albums",
		("Aantal Eigen Albums"/"Aantal Albums") AS Percentage
FROM
(SELECT	Name,
		(SELECT COUNT(Album.Title)
		FROM ArtistAlbumLink INNER JOIN Album ON ArtistAlbumLink.AlbumID = Album.AlbumID
		WHERE
			ArtistAlbumLink.ArtistPersonID = ArtistPerson.ArtistPersonID AND Name NOT LIKE '(%'
		GROUP BY
			ArtistAlbumLink.ArtistPersonID
		) AS AantalAlbums,
		(SELECT COUNT(Album.Title)
		FROM ArtistAlbumLink INNER JOIN Album ON ArtistAlbumLink.AlbumID = Album.AlbumID
		WHERE
			ArtistAlbumLink.ArtistPersonID = ArtistPerson.ArtistPersonID AND Album.StatusID = 1
		GROUP BY
			ArtistAlbumLink.ArtistPersonID
		) AS EigenAlbums
FROM
	ArtistPerson
)
WHERE
	AantalAlbums > 5
ORDER BY
	AantalAlbums DESC, Name
